package com.platform.usercenter.dataprocessing;

/**
 * @Description: sql语句
 * @Author: wcs
 * @Date: 2024-09-25 17:40
 **/
public class SqlConstant {


    public static final String INSERT_ORG = "INSERT into `platform-usercenter`.sys_organization_dept\n" +
            "(\n" +
            "dept_id,\n" +
            "org_id,\n" +
            "parent_id,\n" +
            "dept_name,\n" +
            "dept_sort,\n" +
            "leader,\n" +
            "phone,\n" +
            "email,\n" +
            "status,\n" +
            "type,\n" +
            "create_by,\n" +
            "create_time\n" +
            ")\n" +
            "SELECT \n" +
            "dept_id,\n" +
            "38 as org_id,\n" +
            "parent_id,\n" +
            "dept_name,\n" +
            "order_num as dept_sort,\n" +
            "leader,\n" +
            "phone,\n" +
            "email,\n" +
            "status,\n" +
            "type,\n" +
            "create_by,\n" +
            "create_time\n" +
            "from `platform-usercenter`.sys_dept\n";



    public static final String CREATE_TABLE_LIKE = "CREATE TABLE %s LIKE %s";

    public static final String DROP_TABLE_IF_EXISTS = "DROP TABLE IF EXISTS %s";

    public static final String RENAME_TABLE = "RENAME TABLE %s TO %s";

}
